Setting Trigger Properties

Trigger Name
Set the trigger name.

Fires
Determine when the trigger actions will be executed relative to the insertion, modification or removal of the associated row.

Events

Insert
Fires the trigger whenever an INSERT statement adds a row to a table.

Update
Fires the trigger whenever an UPDATE statement changes a value in one of the columns specified in Update of. If no Update of are present, the trigger will be fired whenever an UPDATE statement changes a value in any column of the table.

Delete
Fires the trigger whenever a DELETE statement removes a row from the table.

Update of
Specify the fields for UPDATE statement trigger upon necessary.

Body
Type in the definition for the trigger.

Hint: To customize the view of the editor and find out more features for sql editing, see Editor View and More Features.

Advanced

When
Specify the trigger condition, which is a SQL condition that must be satisfied for the database to fire the trigger.